Wildfly Performance Tuning by Arnold Johansson

Author:Arnold Johansson [Johansson, Arnold]
Language: eng
Format: epub
Publisher: Packt Publishing
Published: 2014-06-24T21:00:00+00:00

Tip

To help you investigate whether indexes are used effectively for a particular query, most database vendors provide the possibility to get feedback from the query analyzer within the database server. As an example, you can use the EXPLAIN command in PostgreSQL for this, as shown in the following line of code:

EXPLAIN SELECT * FROM product WHERE family=13;

Few JPA/Hibernate users seem to know that it is possible to define indexes in the table configuration with Hibernate. For example, if you need to define an index named index1 on the columns column1 and column2, you can use the following simple annotation:

@Table(appliesTo="tableName", indexes = { @Index(name="index1", columnNames={"column1","column2"})})

Download

Copyright Disclaimer:
This site does not store any files on its server. We only index and link to content provided by other sites. Please contact the content providers to delete copyright contents if any and email us, we'll remove relevant links or contents immediately.